/*
 Navicat Premium Data Transfer

 Source Server         : sql server
 Source Server Type    : SQL Server
 Source Server Version : 16001135 (16.00.1135)
 Source Catalog        : Graduate Admission System
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 16001135 (16.00.1135)
 File Encoding         : 65001

 Date: 20/12/2024 14:58:20
*/


-- ----------------------------
-- Table structure for web_teacherid
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[web_teacherid]') AND type IN ('U'))
	DROP TABLE [dbo].[web_teacherid]
GO

CREATE TABLE [dbo].[web_teacherid] (
  [teacher_id_field] nvarchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[web_teacherid] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of web_teacherid
-- ----------------------------
INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'001')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'002')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'003')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'004')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'005')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'006')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'007')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'008')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'009')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'010')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'011')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'012')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'013')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'014')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'015')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'016')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'017')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'018')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'019')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'020')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'021')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'022')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'023')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'024')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'025')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'026')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'027')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'028')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'029')
GO

INSERT INTO [dbo].[web_teacherid] ([teacher_id_field]) VALUES (N'030')
GO


-- ----------------------------
-- Primary Key structure for table web_teacherid
-- ----------------------------
ALTER TABLE [dbo].[web_teacherid] ADD CONSTRAINT [PK__web_teac__C87DF6E31EAB0A85] PRIMARY KEY CLUSTERED ([teacher_id_field])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

